Profile listings

Dataset statistics

Number of variables	18
Number of observations	100
Missing cells	218
Missing cells (%)	12.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	14.2 KiB
Average record size in memory	145.3 B

Variable types

Numeric	11
Text	2
Unsupported	2
Categorical	2
DateTime	1

Alerts

`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id`	High correlation
`latitude` is highly overall correlated with `longitude` and 2 other fields	High correlation
`longitude` is highly overall correlated with `latitude` and 1 other fields	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month` and 1 other fields	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`neighbourhood` is highly overall correlated with `latitude` and 1 other fields	High correlation
`room_type` is highly overall correlated with `latitude`	High correlation
`neighbourhood_group` has 100 (100.0%) missing values	Missing
`last_review` has 9 (9.0%) missing values	Missing
`reviews_per_month` has 9 (9.0%) missing values	Missing
`license` has 100 (100.0%) missing values	Missing
`id` has unique values	Unique
`neighbourhood_group` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`license` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`number_of_reviews` has 9 (9.0%) zeros	Zeros
`availability_365` has 9 (9.0%) zeros	Zeros
`number_of_reviews_ltm` has 23 (23.0%) zeros	Zeros

Reproduction

Analysis started	2023-10-29 18:07:56.949571
Analysis finished	2023-10-29 18:08:58.432604
Duration	1 minute and 1.48 second
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	147795.23

Minimum	17878
Maximum	262466
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	17878
5-th percentile	49165.1
Q1	89885.25
median	139388.5
Q3	204501.25
95-th percentile	249348.95
Maximum	262466
Range	244588
Interquartile range (IQR)	114616

Descriptive statistics

Standard deviation	66244.816
Coefficient of variation (CV)	0.44822026
Kurtosis	-1.1578439
Mean	147795.23
Median Absolute Deviation (MAD)	52018.5
Skewness	0.061946276
Sum	14779523
Variance	4.3883757 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17878	1	1.0%
173709	1	1.0%
200568	1	1.0%
198665	1	1.0%
191955	1	1.0%
190906	1	1.0%
188155	1	1.0%
186604	1	1.0%
178951	1	1.0%
178833	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17878	1	1.0%
25026	1	1.0%
35764	1	1.0%
48305	1	1.0%
48901	1	1.0%
49179	1	1.0%
51703	1	1.0%
53533	1	1.0%
60718	1	1.0%
64795	1	1.0%

Value	Count	Frequency (%)
262466	1	1.0%
257618	1	1.0%
256323	1	1.0%
251868	1	1.0%
249842	1	1.0%
249323	1	1.0%
248756	1	1.0%
247779	1	1.0%
247052	1	1.0%
245951	1	1.0%

name
Text

Distinct	94
Distinct (%)	94.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

Length

Max length	83
Median length	70
Mean length	64.65
Min length	42

Characters and Unicode

Total characters	6465
Distinct characters	51
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	88 ?
Unique (%)	88.0%

Sample

1st row	Condo in Rio de Janeiro · ★4.70 · 2 bedrooms · 2 beds · 1 bath
2nd row	Rental unit in Rio de Janeiro · ★4.71 · 1 bedroom · 1 bed · 1 bath
3rd row	Loft in Rio de Janeiro · ★4.90 · 1 bedroom · 1 bed · 1.5 baths
4th row	Rental unit in Ipanema · ★4.74 · 6 bedrooms · 7 beds · 7 baths
5th row	Rental unit in Rio · ★4.37 · 4 bedrooms · 5 beds · 3 baths

Value	Count	Frequency (%)
·	387	23.8%
1	170	10.4%
in	100	6.1%
rio	91	5.6%
de	83	5.1%
janeiro	83	5.1%
unit	76	4.7%
rental	76	4.7%
bedroom	64	3.9%
bath	64	3.9%
Other values (86)	434	26.7%

Most occurring characters

Value	Count	Frequency (%)
	1529	23.7%
e	470	7.3%
o	396	6.1%
·	387	6.0%
i	365	5.6%
n	349	5.4%
a	304	4.7%
d	300	4.6%
b	292	4.5%
t	277	4.3%
Other values (41)	1796	27.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3499	54.1%
Space Separator	1529	23.7%
Decimal Number	565	8.7%
Other Punctuation	488	7.5%
Uppercase Letter	294	4.5%
Other Symbol	90	1.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	470	13.4%
o	396	11.3%
i	365	10.4%
n	349	10.0%
a	304	8.7%
d	300	8.6%
b	292	8.3%
t	277	7.9%
r	197	5.6%
s	135	3.9%
Other values (14)	414	11.8%

Uppercase Letter

Value	Count	Frequency (%)
R	167	56.8%
J	84	28.6%
S	10	3.4%
H	8	2.7%
L	7	2.4%
C	7	2.4%
T	3	1.0%
I	2	0.7%
B	2	0.7%
P	1	0.3%
Other values (3)	3	1.0%

Decimal Number

Value	Count	Frequency (%)
1	191	33.8%
4	108	19.1%
2	71	12.6%
7	40	7.1%
5	37	6.5%
8	34	6.0%
3	26	4.6%
6	23	4.1%
0	21	3.7%
9	14	2.5%

Other Punctuation

Value	Count	Frequency (%)
·	387	79.3%
.	101	20.7%

Space Separator

Value	Count	Frequency (%)
	1529	100.0%

Other Symbol

Value	Count	Frequency (%)
★	90	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3793	58.7%
Common	2672	41.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	470	12.4%
o	396	10.4%
i	365	9.6%
n	349	9.2%
a	304	8.0%
d	300	7.9%
b	292	7.7%
t	277	7.3%
r	197	5.2%
R	167	4.4%
Other values (27)	676	17.8%

Common

Value	Count	Frequency (%)
	1529	57.2%
·	387	14.5%
1	191	7.1%
4	108	4.0%
.	101	3.8%
★	90	3.4%
2	71	2.7%
7	40	1.5%
5	37	1.4%
8	34	1.3%
Other values (4)	84	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5986	92.6%
None	389	6.0%
Misc Symbols	90	1.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1529	25.5%
e	470	7.9%
o	396	6.6%
i	365	6.1%
n	349	5.8%
a	304	5.1%
d	300	5.0%
b	292	4.9%
t	277	4.6%
r	197	3.3%
Other values (37)	1507	25.2%

None

Value	Count	Frequency (%)
·	387	99.5%
ç	1	0.3%
á	1	0.3%

Misc Symbols

Value	Count	Frequency (%)
★	90	100.0%

host_id
Real number (ℝ)

HIGH CORRELATION

Distinct	88
Distinct (%)	88.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	759383.9

Minimum	68997
Maximum	6416134
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	68997
5-th percentile	109643.9
Q1	475676.75
median	645419.5
Q3	904996.5
95-th percentile	1322631.2
Maximum	6416134
Range	6347137
Interquartile range (IQR)	429319.75

Descriptive statistics

Standard deviation	685168.24
Coefficient of variation (CV)	0.90226858
Kurtosis	47.132344
Mean	759383.9
Median Absolute Deviation (MAD)	187383.5
Skewness	5.8482637
Sum	75938390
Variance	4.6945551 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
792218	6	6.0%
474221	4	4.0%
1207700	3	3.0%
70933	2	2.0%
856145	2	2.0%
68997	1	1.0%
842466	1	1.0%
980805	1	1.0%
969899	1	1.0%
929229	1	1.0%
Other values (78)	78	78.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
68997	1	1.0%
70933	2	2.0%
93005	1	1.0%
102840	1	1.0%
110002	1	1.0%
153691	1	1.0%
222884	1	1.0%
224192	1	1.0%
235496	1	1.0%
238091	1	1.0%

Value	Count	Frequency (%)
6416134	1	1.0%
2182548	1	1.0%
1377161	1	1.0%
1355685	1	1.0%
1348172	1	1.0%
1321287	1	1.0%
1309444	1	1.0%
1306210	1	1.0%
1298591	1	1.0%
1295841	1	1.0%

host_name
Text

Distinct	87
Distinct (%)	87.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

Length

Max length	24
Median length	16
Mean length	7.53
Min length	3

Characters and Unicode

Total characters	753
Distinct characters	56
Distinct categories	7 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81 ?
Unique (%)	81.0%

Sample

1st row	Matthias
2nd row	Viviane
3rd row	Patricia Miranda & Paulo
4th row	Goitaca
5th row	Marcio

Value	Count	Frequency (%)
levy	6	4.5%
	6	4.5%
june	4	3.0%
e	4	3.0%
maria	3	2.2%
luiza	3	2.2%
casa	2	1.5%
da	2	1.5%
❤️	2	1.5%
ana	2	1.5%
Other values (95)	100	74.6%

Most occurring characters

Value	Count	Frequency (%)
a	123	16.3%
i	65	8.6%
e	58	7.7%
r	52	6.9%
n	47	6.2%
o	41	5.4%
l	37	4.9%
	35	4.6%
s	22	2.9%
t	20	2.7%
Other values (46)	253	33.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	580	77.0%
Uppercase Letter	126	16.7%
Space Separator	35	4.6%
Other Punctuation	6	0.8%
Other Symbol	2	0.3%
Nonspacing Mark	2	0.3%
Decimal Number	2	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	123	21.2%
i	65	11.2%
e	58	10.0%
r	52	9.0%
n	47	8.1%
o	41	7.1%
l	37	6.4%
s	22	3.8%
t	20	3.4%
u	19	3.3%
Other values (16)	96	16.6%

Uppercase Letter

Value	Count	Frequency (%)
L	13	10.3%
M	13	10.3%
C	13	10.3%
A	11	8.7%
R	10	7.9%
J	8	6.3%
G	7	5.6%
E	6	4.8%
S	6	4.8%
D	6	4.8%
Other values (13)	33	26.2%

Other Punctuation

Value	Count	Frequency (%)
&	5	83.3%
,	1	16.7%

Decimal Number

Value	Count	Frequency (%)
4	1	50.0%
8	1	50.0%

Space Separator

Value	Count	Frequency (%)
	35	100.0%

Other Symbol

Value	Count	Frequency (%)
❤	2	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
️	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	706	93.8%
Common	45	6.0%
Inherited	2	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	123	17.4%
i	65	9.2%
e	58	8.2%
r	52	7.4%
n	47	6.7%
o	41	5.8%
l	37	5.2%
s	22	3.1%
t	20	2.8%
u	19	2.7%
Other values (39)	222	31.4%

Common

Value	Count	Frequency (%)
	35	77.8%
&	5	11.1%
❤	2	4.4%
,	1	2.2%
4	1	2.2%
8	1	2.2%

Inherited

Value	Count	Frequency (%)
️	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	747	99.2%
Dingbats	2	0.3%
VS	2	0.3%
None	2	0.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	123	16.5%
i	65	8.7%
e	58	7.8%
r	52	7.0%
n	47	6.3%
o	41	5.5%
l	37	5.0%
	35	4.7%
s	22	2.9%
t	20	2.7%
Other values (42)	247	33.1%

Dingbats

Value	Count	Frequency (%)
❤	2	100.0%

VS

Value	Count	Frequency (%)
️	2	100.0%

None

Value	Count	Frequency (%)
â	1	50.0%
á	1	50.0%

neighbourhood_group
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	100
Missing (%)	100.0%
Memory size	932.0 B

neighbourhood
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

Copacabana	43
Ipanema	12
Santa Teresa	7
Leblon	4
Botafogo	4
Other values (20)	30

Length

Max length	24
Median length	15
Mean length	9.36
Min length	3

Characters and Unicode

Total characters	936
Distinct characters	39
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13 ?
Unique (%)	13.0%

Sample

1st row	Copacabana
2nd row	Copacabana
3rd row	Copacabana
4th row	Ipanema
5th row	Copacabana

Common Values

Value	Count	Frequency (%)
Copacabana	43	43.0%
Ipanema	12	12.0%
Santa Teresa	7	7.0%
Leblon	4	4.0%
Botafogo	4	4.0%
Barra da Tijuca	3	3.0%
Laranjeiras	3	3.0%
Jacarepaguá	3	3.0%
Centro	2	2.0%
Flamengo	2	2.0%
Other values (15)	17	17.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
copacabana	43	36.1%
ipanema	12	10.1%
santa	7	5.9%
teresa	7	5.9%
leblon	4	3.4%
botafogo	4	3.4%
tijuca	4	3.4%
barra	3	2.5%
da	3	2.5%
laranjeiras	3	2.5%
Other values (23)	29	24.4%

Most occurring characters

Value	Count	Frequency (%)
a	274	29.3%
n	80	8.5%
o	71	7.6%
p	58	6.2%
c	53	5.7%
e	52	5.6%
b	47	5.0%
C	46	4.9%
r	32	3.4%
t	20	2.1%
Other values (29)	203	21.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	802	85.7%
Uppercase Letter	115	12.3%
Space Separator	19	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	274	34.2%
n	80	10.0%
o	71	8.9%
p	58	7.2%
c	53	6.6%
e	52	6.5%
b	47	5.9%
r	32	4.0%
t	20	2.5%
m	19	2.4%
Other values (15)	96	12.0%

Uppercase Letter

Value	Count	Frequency (%)
C	46	40.0%
I	13	11.3%
T	11	9.6%
S	10	8.7%
B	9	7.8%
L	9	7.8%
J	5	4.3%
G	4	3.5%
F	2	1.7%
H	2	1.7%
Other values (3)	4	3.5%

Space Separator

Value	Count	Frequency (%)
	19	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	917	98.0%
Common	19	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	274	29.9%
n	80	8.7%
o	71	7.7%
p	58	6.3%
c	53	5.8%
e	52	5.7%
b	47	5.1%
C	46	5.0%
r	32	3.5%
t	20	2.2%
Other values (28)	184	20.1%

Common

Value	Count	Frequency (%)
	19	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	923	98.6%
None	13	1.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	274	29.7%
n	80	8.7%
o	71	7.7%
p	58	6.3%
c	53	5.7%
e	52	5.6%
b	47	5.1%
C	46	5.0%
r	32	3.5%
t	20	2.2%
Other values (24)	190	20.6%

None

Value	Count	Frequency (%)
á	9	69.2%
ú	1	7.7%
ç	1	7.7%
â	1	7.7%
ó	1	7.7%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	99
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-22.967203

Minimum	-23.03154
Maximum	-22.895768
Zeros	0
Zeros (%)	0.0%
Negative	100
Negative (%)	100.0%
Memory size	932.0 B

Quantile statistics

Minimum	-23.03154
5-th percentile	-22.993978
Q1	-22.982473
median	-22.97671
Q3	-22.960903
95-th percentile	-22.914793
Maximum	-22.895768
Range	0.1357721
Interquartile range (IQR)	0.02157

Descriptive statistics

Standard deviation	0.026289685
Coefficient of variation (CV)	-0.001144662
Kurtosis	0.66339654
Mean	-22.967203
Median Absolute Deviation (MAD)	0.008865
Skewness	0.93535993
Sum	-2296.7203
Variance	0.00069114754
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22.98114	2	2.0%
-22.96599	1	1.0%
-22.96104	1	1.0%
-22.98586	1	1.0%
-22.96055	1	1.0%
-22.95644	1	1.0%
-22.98057	1	1.0%
-22.96775	1	1.0%
-22.90544	1	1.0%
-22.98068	1	1.0%
Other values (89)	89	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23.03154	1	1.0%
-23.01124	1	1.0%
-23.0102	1	1.0%
-23.00809	1	1.0%
-23.00744	1	1.0%
-22.99327	1	1.0%
-22.98812	1	1.0%
-22.98752	1	1.0%
-22.98697	1	1.0%
-22.9869	1	1.0%

Value	Count	Frequency (%)
-22.8957679	1	1.0%
-22.90022	1	1.0%
-22.90544	1	1.0%
-22.90559	1	1.0%
-22.91258	1	1.0%
-22.91491	1	1.0%
-22.91666	1	1.0%
-22.9172	1	1.0%
-22.91742	1	1.0%
-22.91882	1	1.0%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	98
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-43.214766

Minimum	-43.49074
Maximum	-43.16858
Zeros	0
Zeros (%)	0.0%
Negative	100
Negative (%)	100.0%
Memory size	932.0 B

Quantile statistics

Minimum	-43.49074
5-th percentile	-43.383467
Q1	-43.202998
median	-43.19107
Q3	-43.186512
95-th percentile	-43.175127
Maximum	-43.16858
Range	0.32216
Interquartile range (IQR)	0.016485

Descriptive statistics

Standard deviation	0.066156204
Coefficient of variation (CV)	-0.0015308703
Kurtosis	6.7430083
Mean	-43.214766
Median Absolute Deviation (MAD)	0.00808
Skewness	-2.7233276
Sum	-4321.4766
Variance	0.0043766433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-43.18969	2	2.0%
-43.18902	2	2.0%
-43.1794	1	1.0%
-43.17786	1	1.0%
-43.22285	1	1.0%
-43.19992	1	1.0%
-43.1995	1	1.0%
-43.18457	1	1.0%
-43.19471	1	1.0%
-43.191158	1	1.0%
Other values (88)	88	88.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-43.49074	1	1.0%
-43.47437	1	1.0%
-43.43045	1	1.0%
-43.41337	1	1.0%
-43.388355	1	1.0%
-43.38321	1	1.0%
-43.37246	1	1.0%
-43.37081	1	1.0%
-43.3538124	1	1.0%
-43.31505	1	1.0%

Value	Count	Frequency (%)
-43.16858	1	1.0%
-43.17442	1	1.0%
-43.17444341	1	1.0%
-43.17478	1	1.0%
-43.17488	1	1.0%
-43.17514	1	1.0%
-43.17563	1	1.0%
-43.17647	1	1.0%
-43.17676	1	1.0%
-43.17757	1	1.0%

room_type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

Entire home/apt	71
Private room	29

Length

Max length	15
Median length	15
Mean length	14.13
Min length	12

Characters and Unicode

Total characters	1413
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Entire home/apt
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	71	71.0%
Private room	29	29.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	71	35.5%
home/apt	71	35.5%
private	29	14.5%
room	29	14.5%

Most occurring characters

Value	Count	Frequency (%)
t	171	12.1%
e	171	12.1%
r	129	9.1%
o	129	9.1%
i	100	7.1%
	100	7.1%
m	100	7.1%
a	100	7.1%
E	71	5.0%
n	71	5.0%
Other values (5)	271	19.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1142	80.8%
Space Separator	100	7.1%
Uppercase Letter	100	7.1%
Other Punctuation	71	5.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	171	15.0%
e	171	15.0%
r	129	11.3%
o	129	11.3%
i	100	8.8%
m	100	8.8%
a	100	8.8%
n	71	6.2%
h	71	6.2%
p	71	6.2%

Uppercase Letter

Value	Count	Frequency (%)
E	71	71.0%
P	29	29.0%

Space Separator

Value	Count	Frequency (%)
	100	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	71	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1242	87.9%
Common	171	12.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	171	13.8%
e	171	13.8%
r	129	10.4%
o	129	10.4%
i	100	8.1%
m	100	8.1%
a	100	8.1%
E	71	5.7%
n	71	5.7%
h	71	5.7%
Other values (3)	129	10.4%

Common

Value	Count	Frequency (%)
	100	58.5%
/	71	41.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1413	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	171	12.1%
e	171	12.1%
r	129	9.1%
o	129	9.1%
i	100	7.1%
	100	7.1%
m	100	7.1%
a	100	7.1%
E	71	5.0%
n	71	5.0%
Other values (5)	271	19.2%

price
Real number (ℝ)

Distinct	81
Distinct (%)	81.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	784.22

Minimum	59
Maximum	25000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	59
5-th percentile	130
Q1	180
median	263.5
Q3	542.25
95-th percentile	2459.4
Maximum	25000
Range	24941
Interquartile range (IQR)	362.25

Descriptive statistics

Standard deviation	2613.3744
Coefficient of variation (CV)	3.3324506
Kurtosis	76.4909
Mean	784.22
Median Absolute Deviation (MAD)	101.5
Skewness	8.3876731
Sum	78422
Variance	6829726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
130	4	4.0%
200	3	3.0%
180	3	3.0%
736	3	3.0%
300	3	3.0%
220	2	2.0%
345	2	2.0%
164	2	2.0%
140	2	2.0%
193	2	2.0%
Other values (71)	74	74.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
59	1	1.0%
101	1	1.0%
107	1	1.0%
126	1	1.0%
130	4	4.0%
133	1	1.0%
140	2	2.0%
142	1	1.0%
145	1	1.0%
147	1	1.0%

Value	Count	Frequency (%)
25000	1	1.0%
7381	1	1.0%
3464	1	1.0%
3448	1	1.0%
2600	1	1.0%
2452	1	1.0%
2054	1	1.0%
1278	1	1.0%
1220	1	1.0%
1107	1	1.0%

minimum_nights
Real number (ℝ)

Distinct	12
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.33

Minimum	1
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	14.35
Maximum	60
Range	59
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	7.5009158
Coefficient of variation (CV)	1.7323131
Kurtosis	32.963639
Mean	4.33
Median Absolute Deviation (MAD)	1
Skewness	5.297872
Sum	433
Variance	56.263737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	33	33.0%
3	31	31.0%
1	14	14.0%
5	6	6.0%
4	6	6.0%
28	3	3.0%
6	2	2.0%
8	1	1.0%
60	1	1.0%
21	1	1.0%
Other values (2)	2	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14	14.0%
2	33	33.0%
3	31	31.0%
4	6	6.0%
5	6	6.0%
6	2	2.0%
7	1	1.0%
8	1	1.0%
14	1	1.0%
21	1	1.0%

Value	Count	Frequency (%)
60	1	1.0%
28	3	3.0%
21	1	1.0%
14	1	1.0%
8	1	1.0%
7	1	1.0%
6	2	2.0%
5	6	6.0%
4	6	6.0%
3	31	31.0%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	73
Distinct (%)	73.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	95.84

Minimum	0
Maximum	540
Zeros	9
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	77
Q3	139.25
95-th percentile	282.95
Maximum	540
Range	540
Interquartile range (IQR)	129.25

Descriptive statistics

Standard deviation	107.56372
Coefficient of variation (CV)	1.122326
Kurtosis	4.1882984
Mean	95.84
Median Absolute Deviation (MAD)	67
Skewness	1.8627065
Sum	9584
Variance	11569.954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	9.0%
4	6	6.0%
6	3	3.0%
37	3	3.0%
106	2	2.0%
87	2	2.0%
226	2	2.0%
3	2	2.0%
42	2	2.0%
9	2	2.0%
Other values (63)	67	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	9.0%
2	1	1.0%
3	2	2.0%
4	6	6.0%
5	1	1.0%
6	3	3.0%
9	2	2.0%
10	2	2.0%
13	1	1.0%
14	1	1.0%

Value	Count	Frequency (%)
540	1	1.0%
458	1	1.0%
446	1	1.0%
421	1	1.0%
301	1	1.0%
282	1	1.0%
272	1	1.0%
250	1	1.0%
230	1	1.0%
226	2	2.0%

last_review
Date

MISSING

Distinct	64
Distinct (%)	70.3%
Missing	9
Missing (%)	9.0%
Memory size	932.0 B

Minimum	2016-01-05 00:00:00
Maximum	2023-09-21 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	68
Distinct (%)	74.7%
Missing	9
Missing (%)	9.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.76747253

Minimum	0.02
Maximum	3.79
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	0.02
5-th percentile	0.04
Q1	0.2
median	0.61
Q3	1.07
95-th percentile	1.86
Maximum	3.79
Range	3.77
Interquartile range (IQR)	0.87

Descriptive statistics

Standard deviation	0.73597342
Coefficient of variation (CV)	0.95895735
Kurtosis	3.9452098
Mean	0.76747253
Median Absolute Deviation (MAD)	0.44
Skewness	1.7451642
Sum	69.84
Variance	0.54165687
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.04	5	5.0%
0.65	4	4.0%
0.06	3	3.0%
0.61	3	3.0%
0.3	3	3.0%
0.57	2	2.0%
0.14	2	2.0%
0.1	2	2.0%
0.02	2	2.0%
1.48	2	2.0%
Other values (58)	63	63.0%
(Missing)	9	9.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	2	2.0%
0.03	1	1.0%
0.04	5	5.0%
0.05	1	1.0%
0.06	3	3.0%
0.07	1	1.0%
0.08	1	1.0%
0.1	2	2.0%
0.12	1	1.0%
0.13	2	2.0%

Value	Count	Frequency (%)
3.79	1	1.0%
3.14	1	1.0%
3.06	1	1.0%
2.82	1	1.0%
1.87	1	1.0%
1.85	2	2.0%
1.68	1	1.0%
1.63	1	1.0%
1.62	1	1.0%
1.54	1	1.0%

calculated_host_listings_count
Real number (ℝ)

Distinct	12
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.49

Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	28
Range	27
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	4.0514245
Coefficient of variation (CV)	1.1608666
Kurtosis	14.893469
Mean	3.49
Median Absolute Deviation (MAD)	1
Skewness	3.2596058
Sum	349
Variance	16.41404
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	40	40.0%
2	22	22.0%
6	7	7.0%
4	7	7.0%
3	7	7.0%
10	6	6.0%
9	3	3.0%
7	3	3.0%
5	2	2.0%
20	1	1.0%
Other values (2)	2	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	40	40.0%
2	22	22.0%
3	7	7.0%
4	7	7.0%
5	2	2.0%
6	7	7.0%
7	3	3.0%
8	1	1.0%
9	3	3.0%
10	6	6.0%

Value	Count	Frequency (%)
28	1	1.0%
20	1	1.0%
10	6	6.0%
9	3	3.0%
8	1	1.0%
7	3	3.0%
6	7	7.0%
5	2	2.0%
4	7	7.0%
3	7	7.0%

availability_365
Real number (ℝ)

ZEROS

Distinct	74
Distinct (%)	74.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	213.65

Minimum	0
Maximum	365
Zeros	9
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	112.75
median	243.5
Q3	321.25
95-th percentile	365
Maximum	365
Range	365
Interquartile range (IQR)	208.5

Descriptive statistics

Standard deviation	122.85373
Coefficient of variation (CV)	0.57502329
Kurtosis	-1.1919049
Mean	213.65
Median Absolute Deviation (MAD)	84.5
Skewness	-0.45734665
Sum	21365
Variance	15093.038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	9.0%
365	6	6.0%
282	2	2.0%
304	2	2.0%
170	2	2.0%
326	2	2.0%
277	2	2.0%
362	2	2.0%
309	2	2.0%
325	2	2.0%
Other values (64)	69	69.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	9.0%
3	1	1.0%
30	1	1.0%
34	1	1.0%
35	1	1.0%
40	1	1.0%
46	1	1.0%
49	1	1.0%
50	1	1.0%
51	1	1.0%

Value	Count	Frequency (%)
365	6	6.0%
364	1	1.0%
363	2	2.0%
362	2	2.0%
359	1	1.0%
342	1	1.0%
341	1	1.0%
340	1	1.0%
335	1	1.0%
328	2	2.0%

number_of_reviews_ltm
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	33
Distinct (%)	33.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.81

Minimum	0
Maximum	68
Zeros	23
Zeros (%)	23.0%
Negative	0
Negative (%)	0.0%
Memory size	932.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	8
Q3	17.25
95-th percentile	33
Maximum	68
Range	68
Interquartile range (IQR)	16.25

Descriptive statistics

Standard deviation	12.446812
Coefficient of variation (CV)	1.1514165
Kurtosis	3.9435473
Mean	10.81
Median Absolute Deviation (MAD)	7.5
Skewness	1.6842205
Sum	1081
Variance	154.92313
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	23	23.0%
2	10	10.0%
8	9	9.0%
1	5	5.0%
25	4	4.0%
3	4	4.0%
13	3	3.0%
10	3	3.0%
12	3	3.0%
22	2	2.0%
Other values (23)	34	34.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	23	23.0%
1	5	5.0%
2	10	10.0%
3	4	4.0%
4	2	2.0%
5	2	2.0%
7	2	2.0%
8	9	9.0%
9	2	2.0%
10	3	3.0%

Value	Count	Frequency (%)
68	1	1.0%
50	1	1.0%
37	1	1.0%
35	1	1.0%
33	2	2.0%
31	1	1.0%
30	2	2.0%
29	1	1.0%
28	1	1.0%
25	4	4.0%

license
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	100
Missing (%)	100.0%
Memory size	932.0 B

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	neighbourhood	room_type
id	1.000	0.871	0.184	0.220	-0.142	-0.052	-0.091	-0.076	0.074	-0.019	-0.112	0.180	0.000
host_id	0.871	1.000	0.207	0.158	-0.214	-0.055	-0.223	-0.196	-0.017	-0.013	-0.241	0.471	0.000
latitude	0.184	0.207	1.000	0.565	-0.234	-0.074	-0.254	-0.171	-0.156	0.019	-0.264	0.780	0.519
longitude	0.220	0.158	0.565	1.000	-0.228	0.117	0.098	0.069	0.026	-0.115	0.089	0.756	0.000
price	-0.142	-0.214	-0.234	-0.228	1.000	-0.039	-0.134	-0.075	-0.287	0.267	-0.125	0.000	0.000
minimum_nights	-0.052	-0.055	-0.074	0.117	-0.039	1.000	0.018	-0.026	-0.035	-0.142	-0.059	0.487	0.210
number_of_reviews	-0.091	-0.223	-0.254	0.098	-0.134	0.018	1.000	0.934	0.255	-0.106	0.786	0.000	0.382
reviews_per_month	-0.076	-0.196	-0.171	0.069	-0.075	-0.026	0.934	1.000	0.145	-0.146	0.761	0.000	0.383
calculated_host_listings_count	0.074	-0.017	-0.156	0.026	-0.287	-0.035	0.255	0.145	1.000	-0.085	0.241	0.000	0.000
availability_365	-0.019	-0.013	0.019	-0.115	0.267	-0.142	-0.106	-0.146	-0.085	1.000	-0.040	0.000	0.235
number_of_reviews_ltm	-0.112	-0.241	-0.264	0.089	-0.125	-0.059	0.786	0.761	0.241	-0.040	1.000	0.000	0.341
neighbourhood	0.180	0.471	0.780	0.756	0.000	0.487	0.000	0.000	0.000	0.000	0.000	1.000	0.455
room_type	0.000	0.000	0.519	0.000	0.000	0.210	0.382	0.383	0.000	0.235	0.341	0.455	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
0	17878	Condo in Rio de Janeiro · ★4.70 · 2 bedrooms · 2 beds · 1 bath	68997	Matthias	NaN	Copacabana	-22.965990	-43.179400	Entire home/apt	279	5	301	2023-09-11	1.87	1	265	25	NaN
1	25026	Rental unit in Rio de Janeiro · ★4.71 · 1 bedroom · 1 bed · 1 bath	102840	Viviane	NaN	Copacabana	-22.977350	-43.191050	Entire home/apt	330	2	272	2023-09-07	1.68	1	203	24	NaN
2	35764	Loft in Rio de Janeiro · ★4.90 · 1 bedroom · 1 bed · 1.5 baths	153691	Patricia Miranda & Paulo	NaN	Copacabana	-22.981070	-43.191360	Entire home/apt	192	3	446	2023-09-11	2.82	1	46	37	NaN
3	48305	Rental unit in Ipanema · ★4.74 · 6 bedrooms · 7 beds · 7 baths	70933	Goitaca	NaN	Ipanema	-22.985910	-43.203020	Entire home/apt	3448	2	152	2023-09-10	0.99	9	306	30	NaN
4	48901	Rental unit in Rio · ★4.37 · 4 bedrooms · 5 beds · 3 baths	222884	Marcio	NaN	Copacabana	-22.965740	-43.175140	Entire home/apt	703	3	20	2023-09-10	0.20	1	307	12	NaN
5	49179	Rental unit in Rio de Janeiro · ★4.81 · 1 bedroom · 1 bed · 1 bath	224192	David	NaN	Copacabana	-22.979100	-43.190080	Entire home/apt	201	4	147	2023-09-05	1.12	20	159	20	NaN
6	51703	Rental unit in Rio de Janeiro · ★4.75 · Studio · 1 bed · 1 bath	238091	Dália	NaN	Copacabana	-22.981731	-43.190571	Entire home/apt	178	3	250	2023-08-28	1.85	2	321	30	NaN
7	53533	Home in Joatinga · ★4.94 · 4 bedrooms · 6 beds · 4 baths	249439	Sherri & Andre	NaN	Joá	-23.008090	-43.291130	Entire home/apt	1278	2	34	2023-07-24	0.24	1	341	8	NaN
8	60718	Rental unit in Rio de Janeiro · ★4.78 · 4 bedrooms · 4 beds · 2 baths	292870	Tânia	NaN	Flamengo	-22.929720	-43.174880	Entire home/apt	690	6	10	2023-02-27	0.06	1	328	2	NaN
9	64795	Rental unit in Rio de Janeiro · ★4.75 · 3 bedrooms · 4 beds · 2.5 baths	93005	Andrea	NaN	Ipanema	-22.981690	-43.202800	Entire home/apt	543	3	64	2023-08-15	0.42	1	156	22	NaN

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
90	245951	Rental unit in Rio de Janeiro · ★4.86 · 1 bedroom · 2 beds · 1 bath	1289982	Carnaval Turismo	NaN	Copacabana	-22.96704	-43.18201	Entire home/apt	300	3	14	2023-06-11	0.10	1	342	1	NaN
91	247052	Rental unit in Rio de Janeiro · 2 bedrooms · 2 beds · 3 baths	1295841	Osmar	NaN	Botafogo	-22.95665	-43.18481	Entire home/apt	736	5	0	NaN	NaN	1	3	0	NaN
92	247779	Rental unit in Rio de Janeiro · ★4.75 · 1 bedroom · 1 bed · 1 bath	1298591	Karina	NaN	Copacabana	-22.98510	-43.19320	Entire home/apt	170	2	147	2023-09-18	1.03	2	57	7	NaN
93	248756	Condo in Rio de Janeiro · ★4.76 · 2 bedrooms · 2 beds · 1.5 baths	804664	Bernardo	NaN	Copacabana	-22.98029	-43.19054	Entire home/apt	358	3	154	2023-09-10	1.06	1	49	18	NaN
94	249323	Rental unit in Rio de Janeiro · ★4.77 · 2 bedrooms · 2 beds · 2.5 baths	1306210	Raphael	NaN	Copacabana	-22.97600	-43.18838	Entire home/apt	616	1	136	2023-09-07	0.94	1	282	31	NaN
95	249842	Rental unit in Rio · ★4.88 · 1 bedroom · 1 bed · 1 shared bath	1309444	Sonia	NaN	Copacabana	-22.96794	-43.18969	Private room	133	2	176	2023-09-02	1.25	3	108	33	NaN
96	251868	Rental unit in Rio de Janeiro · ★4.84 · 1 bedroom · 3 beds · 1 bath	1321287	Helena	NaN	Copacabana	-22.97920	-43.19010	Entire home/apt	130	4	87	2023-02-21	0.61	2	63	2	NaN
97	256323	Guest suite in Santa Teresa · ★4.81 · 1 bedroom · 1 bed · 1 bath	1348172	Jennifer	NaN	Santa Teresa	-22.91742	-43.18330	Entire home/apt	195	3	226	2023-09-09	1.62	1	140	15	NaN
98	257618	Rental unit in Rio de Janeiro · ★4.73 · 1 bedroom · 1 bed · 1 private bath	1355685	Jorge	NaN	Leme	-22.96102	-43.16858	Private room	209	2	42	2022-09-12	0.29	2	212	0	NaN
99	262466	Rental unit in Rio de Janeiro · ★5.0 · 1 bedroom · 1 bed · 1 bath	1377161	Ana Cristina	NaN	Botafogo	-22.95508	-43.18251	Entire home/apt	250	1	3	2016-01-05	0.02	1	143	0	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Other Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Misc Symbols

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Space Separator

Other Symbol

Nonspacing Mark

Most occurring scripts

Most frequent character per script

Latin

Common

Inherited

Most occurring blocks

Most frequent character per block

ASCII

Dingbats

VS

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample